Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
ItemSaleAssociateSequenceNumber (PK) | A sequential counter used to uniquely identify an instance of a COMMISSION MODIFIER. | AI_MDFR_CMN | LineNumber | smallint | |
WorkerID (FK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
AssociateActionID (FK) | A unique system assigned identifier for an action that is performed by a Worker while assisting a customer purchasing the merchandise or services. | ID_ACTN_ASCTE | Code2 | char(2) | SalesAssociateAction(CO_SLS_ASCTE_ACTN) |
ActionDatetime | The date and time that the associate performed the action for which a commission is payable. | TS_ACTN | AuditDateTime | datetime | |
CommissionAmount | Defines the flat amount of commission earned on the sale of this item | MO_CMN | Money | decimal(16,5) | |
CommissionPercent | Defines the percentage applied to the sold-at retail amount to arrive at the commission for an item or service sold in the SALE/RETURN LINE ITEM. | PE_CMN | Percent | decimal(7,4) | |
CommissionOverrideFlag | A flag denoting that the commission calculation contained in this entity was not made with the normal commission calculation rules. | FL_CMN_OVR | Flag | integer | |
MethodCode | A code denoting the commission calculation method to be used. | FL_PE_CMN_AMT | Code | varchar(20) | |